package com.bonc.rms.mapper;

import java.sql.Date;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

public interface SalaryRecordMapper {

	List<Map<String, Object>> getSalaryRecordByJobNumber(@Param("jobNumber") String jobNumber);

	List<Map<String, Object>> getSalaryRecordByJobNumberAndBetweenDate(@Param("jobNumber") String jobNumber,@Param("startDate") Date startDate,@Param("endDate") Date endDate);

	List<Map<String, Object>> getSalaryRecordByJobNumberAndBeforeDate(@Param("jobNumber") String jobNumber,@Param("beforeDate") Date beforeDate);

	List<Map<String, Object>> getSalaryRecordByJobNumberAndAfterDate(@Param("jobNumber") String jobNumber,@Param("afterDate") Date afterDate);

}
